package daikoku.utils;

public class SQLUtils {

	/**
	 * 
	 * @param count
	 * @return
	 */
	public static String pstmtParameters(int count) {
		StringBuilder sb = new StringBuilder();
		for (int i = 0; i < count; i++) {
			sb.append(", ?");
		}
		return sb.substring(2);
	}

	public static String columns(int count) {
		StringBuilder sb = new StringBuilder();
		for (int i = 1; i <= count; i++) {
			sb.append(", d" + (i < 10 ? "0" + i : i));
		}
		return sb.substring(2);
	}

	public static void main(String[] args) {
		System.out.println(SQLUtils.pstmtParameters(60));
		System.out.println(SQLUtils.columns(60));
	}
}
